#!/usr/bin/python
# _*_ code: utf-8 _*_

import sqlite3 as lite
import sys

cars = (
    (1, 'Audi', 52642),
    (2, 'Mercedes', 57127),
    (3, 'Skoda', 9000),
    (4, 'Volvo', 29000),
    (5, 'Bentley', 350000),
    (6, 'Hummer', 414000),
    (7, 'Volkswagen', 21600)
)

con = lite.connect('test.db')

with con:
    cur = con.cursor()

    cur.execute('DROP TABLE IF EXISTS Cars')
    cur.execute('CREATE TABLE Cars(Id INT, Name TEXT, Price INT)')
    cur.executemany('INSERT INTO Cars VALUES (?, ?, ?)', cars)

